package com.trkj.dao.jpa;

import java.math.BigDecimal;
import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojos.Tbpost;

public interface IHwcPostDAO extends CrudRepository<Tbpost, Long> {
	
	/**
	 * 显示职务
	 * long titleNo, BigDecimal postno, String titleName
	 */
	@Query("select new Tbpost(p.postNo,p.postName) from Tbpost p where p.postNo!=9999")
	public List<Tbpost>queryAllTbpost();
}
